﻿CREATE VIEW [dbo].[vwProjectCategory]
AS
SELECT     p.ProjectID, c.CategoryID, c.Name, c.Abbreviation, pc.Duration AS EstDuration
FROM         dbo.ProjectCategories pc INNER JOIN
                      dbo.Categories c ON pc.CategoryID = c.CategoryID INNER JOIN
                      dbo.Projects p ON pc.ProjectID = p.ProjectID;

